package com.qhw.jdbc;

public class AppTest {
    public static void main(String[] args) throws Exception {
        JdbcUtils jdbcUtils = new JdbcUtils();
        int i =0;
        i = jdbcUtils.update("insert into `user` (username,`password`)values('neo',MD5(123))");
        if (i>0)
            System.out.println("插入成功");
        i = jdbcUtils.update("update `user` set `password` = MD5(290) where id =4");
        if (i>0)
            System.out.println("修改成功");
        i = jdbcUtils.update("delete from `user` where `id` = 6");
        if (i>0)
            System.out.println("删除成功");
       // i = jdbcUtils.select("select id ,username from `user`");
        jdbcUtils.select("select id ,username from `user` order by id");



    }
}
